UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Q5VhFB96dAIb81Y6pB4mmQsHM6o2T2gwxxh2pwxswc='
WHERE
key_id = '1c76b1f9b0c5da5147d820882ba7302a52f7693a1b0f91f8ce1ed167175f8237'
AND (
token = '7Q5VhFB96dAIb81Y6pB4mmQsHM6o2T2gwxxh2pwxswc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)