UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JNzZNsC7WAHp5epIU5odJXceIYCQ1v3hFf8/9lM/FjI='
WHERE
key_id = '780c4ea4a3dc03a2a39567243dc20867903beb5b4737c4ca738f997184a73be7'
AND (
token = 'JNzZNsC7WAHp5epIU5odJXceIYCQ1v3hFf8/9lM/FjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)