When blocking a user, CI related queries are executed after the user's
state transitions to the "blocked" state. This commit ensures those
queries don't run in the same transaction as is used to update the user.

This fixes https://gitlab.com/gitlab-org/gitlab/-/issues/346235

Changelog: fixed