UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J2W3f8XOTbHEiKtzrUcgNlOMC5mxBs5q3FMgvHsCKaA='
WHERE
key_id = 'd62e408dff16c3225998b9e8d6953e518996787382e3c645c3faa3310563f6e5'
AND (
token = 'J2W3f8XOTbHEiKtzrUcgNlOMC5mxBs5q3FMgvHsCKaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)