DELETE FROM revocations WHERE revocation_type = :revocation_type:;