UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+ujgtxZDsCjSey4al3wYVw91TD6QA44EOdr19NSDaU='
WHERE
key_id = 'a96b511489e91abdbc62efcc4acbc6684ba06a681ef64b5ec464d492f609e1df'
AND (
token = 'r+ujgtxZDsCjSey4al3wYVw91TD6QA44EOdr19NSDaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)