there’s a pretty nifty 4 stage rotation mechanism that solves most, but not all, of those race conditions. More info on it in the post and the docs.
These were mentioned around the custom rotation strategy, any pointers to docs describing how it is done if the secret is an RDS Secret?