[Security] Implement API Key Rotation Support

[Abd-Standard]

Description

Organizations should be able to rotate API credentials without service interruptions.

Tasks
Support multiple active keys.
Create rotation workflow.
Add audit logging.
Update documentation.

Acceptance Criteria
API keys rotate successfully.
Existing integrations continue functioning.
Rotation history is logged.

[Silver36-ship-it]

I would love to work on this professionally, please assign it to me

[vicajohn]

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

Hi, I would love to work on this.

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

[grantfox-oss]

🦊 GrantFox — @vicajohn 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 #196)
2. Your PR will be reviewed by the Core-Foundry maintainers

Good luck! Track your progress on GrantFox.

[drips-wave]

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

🧑‍💻 @vicajohn: 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]

🎉 This issue has been marked as completed on GrantFox!

@vicajohn's PR #325 was approved and merged by @Abd-Standard.

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

👏 Great work, @vicajohn! Keep contributing to Core-Foundry.