UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bt8Jc8yUAcV4RssCulEg6kTloUc/28EAAS/vRND0AME='
WHERE
key_id = 'bf9284924d6a150fd611ebfac42f4288328ae3fd9782698d8db2e2cb708c242d'
AND (
token = 'Bt8Jc8yUAcV4RssCulEg6kTloUc/28EAAS/vRND0AME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)