fix: do not iteratively delete records

Resolves performance issues on some databases when deleting consent.

BREAKING CHANGES: Deleting consents no longer returns 404 in certain edge cases but instead always 204.

Related issue(s)

[ ] I have read the contributing guidelines.
[ ] I have referenced an issue containing the design document if my change introduces a new feature.
[ ] I am following the contributing code guidelines.
[ ] I have read the security policy.
[ ] I confirm that this pull request does not address a security vulnerability. If this pull request addresses a security vulnerability, I confirm that I got the approval (please contact security@ory.sh) from the maintainers to push the changes.
[ ] I have added tests that prove my fix is effective or that my feature works.
[ ] I have added or changed the documentation.