UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xL9M72YK0gTM1+ajPryHKzJ8HwGppkw+U2JOZvMe0Xs='
WHERE
key_id = 'c5d5964227999a209cd52e65d2536d35b22e1216958d16c23c2a183ebcb9acfc'
AND (
token = 'xL9M72YK0gTM1+ajPryHKzJ8HwGppkw+U2JOZvMe0Xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)