UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXEm8mC34mIzkcEklxk1CdeNI3lM2PzOeMwrNtQz7v8='
WHERE
key_id = 'bad4eb435a84de3ac6c94985e5c85622cc38e42e4fb72cc0119ea614e996b5ca'
AND (
token = 'cXEm8mC34mIzkcEklxk1CdeNI3lM2PzOeMwrNtQz7v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)