Email Activation Link: 403 Error on Second Click
### Node Version

22

### NPM/Yarn/PNPM Version

10.9.0

### Strapi Version

5.7.0

### Operating System

MacOS

### Database

PostgreSQL

### Javascript or Typescript

Typescript

### Reproduction URL

_No response_

### Bug Description


Description

With Strapi v5, there is an issue with the email activation link. When a user clicks the activation link a second time, it redirects to a 403 Forbidden error page.

<img width="1166" alt="Image" src="https://github.com/user-attachments/assets/97cfcdea-970b-4b22-a57f-e1a61c8319e0" />


This is problematic because some email providers (e.g., security bots or email preview systems) automatically navigate the activation link before the user even has a chance to click it. As a result, the user encounters a 403 error on their first manual click, creating confusion and preventing account activation.

Actual Behavior

The second click on the activation link results in a 403 Forbidden error.

Impact
	•	Causes confusion for end-users who may not understand why their activation fails.
	•	Hinders account registration for users with email systems that preemptively “test” links.


Additional Context

This issue could potentially be resolved by implementing a mechanism that handles duplicate link activations gracefully, such as:
	•	Displaying a message confirming the account is already activated.
	•	Allowing reactivation or revalidating the link.

Let me know if you need help providing more information!

### Steps to Reproduce

	1.	Send an account activation email through Strapi v5.
	2.	Click the activation link the first time (simulating an automated click by an email provider).
	3.	Attempt to click the link again manually as the user.
	4.	Observe the 403 error on the second attempt.

### Expected Behavior

The activation link should:
	•	Be idempotent and not fail on a second click.
	•	Redirect the user to a relevant page, such as a message indicating the account is already activated, instead of throwing a 403 error.


### Logs

```shell

```

### Code Snippets

_No response_

### Media

_No response_

### Additional information

_No response_

### Confirmation Checklist

- [x] I have checked the existing [issues](https://github.com/strapi/strapi/issues) for duplicates.
- [x] I agree to follow this project's [Code of Conduct](https://github.com/strapi/strapi/blob/develop/CODE_OF_CONDUCT.md).