UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9k1KBVR7uUZJ1vQxObHhBAh4LbJwfC20++7T3oMFK8='
WHERE
key_id = '5fbe26068d9e957e988d359ebd55dd650fb82c418ddaff91b05aae481d8b914a'
AND (
token = 'H9k1KBVR7uUZJ1vQxObHhBAh4LbJwfC20++7T3oMFK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)