UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTrQBL4+1MMvfzWmn+ovbcUaO5v1elM/ieyW1fzSscI='
WHERE
key_id = '787910d071bcc8898c6b0ae7ead3e64952b382231b4cae131ba86b6796b74ce6'
AND (
token = 'bTrQBL4+1MMvfzWmn+ovbcUaO5v1elM/ieyW1fzSscI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)