Make OP-initiated logout stateless

[alnr]

Preflight checklist

• I could not find a solution in the existing issues, docs, nor discussions.
• I agree to follow this project's Code of Conduct.
• I have read and am following this repository's Contribution Guidelines.
• I have joined the Ory Community Slack.
• I am signed up to the Ory Security Patch Newsletter.

Ory Network Project

No response

Describe your problem

OP-initiated logouts hit the database many times and leave stale rows in the database without a creation or expiration date.

Describe your ideal solution

Should be pretty straightforward to use the stateless AEAD-based flow used in the Authorization Code grant for this purpose as well, allowing us to completely drop this table and make logouts much faster as well.

Workarounds or alternatives

Add expiration dates to logout requests and let TTL jobs/janitor handle the cleanup.

Version

all

Additional Context

No response

[aeneasr]

As a workaround, we added expiry and requested at times to the table.