UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hy5baNjusFfVc+SNpITEH1V+GuoJohkTlY4j97okkW8='
WHERE
key_id = '1d5d8204bc7b37f60669c0e279dd9a7e7ff0fa25070bd50bdbedf9ab72bc4c03'
AND (
token = 'hy5baNjusFfVc+SNpITEH1V+GuoJohkTlY4j97okkW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)