Use a token in your app.
Have a table of tokens for me they are generally a Guid and a description.
First transaction gets an update lock on the token,
does what it needs then rolls back the update.

Other threads fail to get update lock on token and exit
Mick