UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7w7fb4JEQZ30rzqCQ9ZQSOQ3UBYsUKQf4wbureKgEs='
WHERE
key_id = 'df80a239200e724a5f58de4bc0834f5d9775aa83fdb82a192b34e456238b0bcf'
AND (
token = 'D7w7fb4JEQZ30rzqCQ9ZQSOQ3UBYsUKQf4wbureKgEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)