UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XaX/khNwJA3Z30GEaatmPRhiqKrCV64woLhrGaT0Y4='
WHERE
key_id = 'a9c69b406c41e5646c9b2d34ce48a1ec4cb22d7811553dcde841267a918697c5'
AND (
token = '1XaX/khNwJA3Z30GEaatmPRhiqKrCV64woLhrGaT0Y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)