UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6K80DNNbvFpwM9WIkkA8Kb/0xegZyoVC5U1jmZ+0M94='
WHERE
key_id = '46d7350fa4321647d84aafb84a95d9f123d51d51871a410d3c7f94489fdb7831'
AND (
token = '6K80DNNbvFpwM9WIkkA8Kb/0xegZyoVC5U1jmZ+0M94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)