UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOgjcr4kVLfpKxc6hrodrh+WbYHxQoh2+Igx0ezX3z4='
WHERE
key_id = '9bee96ad56f4eeb9ea6d4322b2ac18b424d7e411af78fe7d5d48991759bf1967'
AND (
token = 'mOgjcr4kVLfpKxc6hrodrh+WbYHxQoh2+Igx0ezX3z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)