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