UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rLZQnKK9y92woVEDBBWPwRzU4NJwrfxrkj89gs1Aoz8='
WHERE
key_id = '848860828aa3c2f8cbb6c7e2be4a4642377055d409a24d3e82263faaa154d83d'
AND (
token = 'rLZQnKK9y92woVEDBBWPwRzU4NJwrfxrkj89gs1Aoz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)