UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hlf2amSg0Ob+fnfiRI+CF/5Vgri4o9QGvPj3q/n0dH8='
WHERE
key_id = '6796311a36321a810d9f8c8aff6078e9fcc36de294c43f76190b9b48c0a219fe'
AND (
token = 'Hlf2amSg0Ob+fnfiRI+CF/5Vgri4o9QGvPj3q/n0dH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)