UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gq1YCUXbqd/yzr+fHqSOI3ORwpbIvH196ft6sXqF7Vc='
WHERE
key_id = '0ffed396e5c64962e107255291b56f7d7df43c29da74b6c70a539adfb60d8c94'
AND (
token = 'Gq1YCUXbqd/yzr+fHqSOI3ORwpbIvH196ft6sXqF7Vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)