UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCsh7gBublkg7jK/m3iPZcpcY1FPFLBxH+tB8787hI8='
WHERE
key_id = '9210627a3e25a7e6537214dde6046bb2b83a0e3ece74471f4a8c764de3c79153'
AND (
token = 'TCsh7gBublkg7jK/m3iPZcpcY1FPFLBxH+tB8787hI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)