Add refresh token rotation for JWT sessions

[robertocarlous]

Summary

Currently JWT sessions have a fixed expiry with no refresh mechanism. Users are logged out abruptly and must re-authenticate with their Stellar keypair, hurting UX.

Proposed Solution

• Issue a short-lived access token (15 min) + a long-lived refresh token (7 days)
• Store refresh token hash in the Session table
• Add POST /api/auth/refresh endpoint
• Rotate refresh token on each use (single-use)
• Revoke all refresh tokens on logout

Acceptance Criteria

• POST /api/auth/refresh returns new access + refresh token pair
• Old refresh token is invalidated after rotation
• Logout revokes both tokens
• Unit tests cover rotation and revocation
• .env.example documents REFRESH_TOKEN_SECRET and REFRESH_TOKEN_TTL

[AlienScroll78]

@AlienScroll78 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hello, I have years of experience working on tasks like this and handling similar challenges across backend, frontend, and smart-contract development. I have carefully read and fully understood the task requirements, and I am confident I can deliver a clean, efficient, and well-tested solution promptly. I always ensure high-quality implementation, maintainability, and adherence to best practices.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @AlienScroll78 to this issue.

[gidadoabdullateef5]

@gidadoabdullateef5 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Assign for God's sake, you shall meet your helper to please

ℹ️ Repo Maintainers: To accept this application, review their application or assign @gidadoabdullateef5 to this issue.

[Uyoxy]

@Uyoxy has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

can i work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Uyoxy to this issue.

[drips-wave]

Congratulations, @Uyoxy! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @Uyoxy: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🦊 GrantFox — @Uyoxy has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #214)
2. Your PR will be reviewed by the Neurowealth maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox!

@Uyoxy's PR #277 was approved and merged by @robertocarlous.

🏆 @Uyoxy: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (328 total points). Track your full progress on GrantFox.

👏 Great work, @Uyoxy! Keep contributing to Neurowealth.

[drips-wave]

This issue has been completed by @Uyoxy as part of the Stellar Wave Program's 6th Wave 🥳

😎 @Uyoxy: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.