UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pV8DqAscojtnmptY9+BvP69sH8SDPe6UO1LBkgdVvAk='
WHERE
key_id = '3336ec0fe17eb2c93d24ac61e24f0b83f9e0cb5fa634e5f2183675b70174a360'
AND (
token = 'pV8DqAscojtnmptY9+BvP69sH8SDPe6UO1LBkgdVvAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)