UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vPHwJr6sbIbIOnXqfXW54v0BANi3hX98u0cw+NZS1Og='
WHERE
key_id = 'ad877d9ba6c2a6083b47b3875baaa65dc6399224f9a7022bd632c8306a763538'
AND (
token = 'vPHwJr6sbIbIOnXqfXW54v0BANi3hX98u0cw+NZS1Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)