SET LOCK_TIMEOUT

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-lock-timeout-transact-sql?view=sql-server-ver16

Specifies the number of milliseconds a statement waits for a lock to be released.

DECLARE @SQL VARCHAR (50) = 'SET LOCK_TIMEOUT 5000;';
EXEC (@SQL);