UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01lZR+lsj74zp4qgankWb5xkWa5yOI0kYHp9+0ri5cw='
WHERE
key_id = 'b505a879d0a6d3a310e7fdd93d39263ef20005719cef438d2b6505bac55913d4'
AND (
token = '01lZR+lsj74zp4qgankWb5xkWa5yOI0kYHp9+0ri5cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)