UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MAohirpNv9TIK9SbkwcEXRoVZwpYY+LPd1SkDDRE6GU='
WHERE
key_id = '678aaaafeef75cf245c547218abe616e7bb49fbe158c8df911b857bcb5778598'
AND (
token = 'MAohirpNv9TIK9SbkwcEXRoVZwpYY+LPd1SkDDRE6GU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)