UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgvPbWDltJf+XhIS03QI+ACfU0R1fKEDyoAyFtAe6oE='
WHERE
key_id = 'af507404bfa7e6642ebef7b5b110732e42d147ebc200632768ee31d5b842b18d'
AND (
token = 'JgvPbWDltJf+XhIS03QI+ACfU0R1fKEDyoAyFtAe6oE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)