UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPY9rdozSlNr2Gbw3tj/T/XaNwvUNPe2YHN/+GimSQE='
WHERE
key_id = 'af60d6c8608cf502c3298efe96c039929545b8e67c87ced22798d84f0ca54377'
AND (
token = 'XPY9rdozSlNr2Gbw3tj/T/XaNwvUNPe2YHN/+GimSQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)