Fixes an edge case where a user could not be deleted if they
held a lock (in the Terraform sense, not a database lock) on a
Terraform state, as it would violate the foreign key constraint.

https://gitlab.com/gitlab-org/gitlab/-/merge_requests/55813