UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KSix5e6oBVtNABxgXuZjv/0xP5RZx0cMqMBO6Ryrhyg='
WHERE
key_id = 'e5a5ec29a9a967578734b0fe38aa3f58247a4867273f03180594805f1a32faaa'
AND (
token = 'KSix5e6oBVtNABxgXuZjv/0xP5RZx0cMqMBO6Ryrhyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)