UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q2PxbVfvBfT6VQWniVvb9HFW8D2yZxF9wSyWP7Qkngw='
WHERE
key_id = '9728927b04e7643d518625d1c9d055b4dc774a9d2059c4bc8c92586ac5b5d9df'
AND (
token = 'q2PxbVfvBfT6VQWniVvb9HFW8D2yZxF9wSyWP7Qkngw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)