Revert "Merge branch 'if-395352-pat_automatic_reuse_detection' into 'master'"

Purpose of revert

This reverts merge request !125270 (merged) as we suspect this is causing row lock contention. See https://gitlab.slack.com/archives/C05H5L57ARH (internal) and 2023-07-14: Intermittent apdex dips for web and... (gitlab-com/gl-infra/production#16042 - closed) for more details

Checklist

• Create an issue to reinstate the merge request and assign it to the author of the reverted merge request.
• If the revert is to resolve a broken 'master' incident, please read through the Responsibilities of the Broken master resolution DRI.
• If the revert involves a database migration, please read through Deleting existing migrations.
• Add the appropriate labels before the MR is created. We can skip CI/CD jobs only if the labels are added before the CI/CD pipeline is created.

Milestone info

• I am reverting something in the current milestone. No changelog is needed, and I've added a ~"regression:*" label.
• I am reverting something in a different milestone. A changelog is needed, and I've removed the ~"regression:*" label.

Related issues and merge requests