Secrets, like passwords, should be rotated on a regular schedule. AWS Secrets Manager can be configured to automatically rotate secrets after a set period and 90 days has become a standard for that minimum. Ensuring this is set can help protect the security of every system using secrets within an organization's AWS environment.
In AWS Console -
In Terraform -
References:
https://docs.aws.amazon.com/secretsmanager/latest/userguide/tutorials.html
https://registry.terraform.io/providers/hashicorp/aws/latest/docs/resources/secretsmanager_secret_rotation#automatically_after_days