UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kB7nwCDy7qx2gI6pbscHMYKeSCqX8SRnbF+b5s0i9G8='
WHERE
key_id = '9146c85e1d83687f24f24a4b9b3e586bed4d964f92cc74a8ea204a698b0317f0'
AND (
token = 'kB7nwCDy7qx2gI6pbscHMYKeSCqX8SRnbF+b5s0i9G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)