UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FZZUJ6QYYd3GH6QGILWEm7m8Skw3NBOiKftlB3Ynchc='
WHERE
key_id = '46c0becdaf50c6247f08ee48cd2c24b2b69ceb8f6af2af112543283cce57b646'
AND (
token = 'FZZUJ6QYYd3GH6QGILWEm7m8Skw3NBOiKftlB3Ynchc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)