S3 Secret auto refresh not working

We create secret and the S3 fetch works fine and the timestamp of S3 credentials match with the timestamp of the temporary credentials. The issue is post the credentials expiry time, the fetch is still probably happening with the same old credential and we are hitting 400 errors. If we put in new secret things start to work again. We are using EC2 IAM Role and does auto refresh work in this case as documented [here](https://duckdb.org/docs/stable/core_extensions/aws.html)

```
CREATE SECRET env_test (
TYPE s3,
PROVIDER credential_chain,
REFRESH auto
);
```

Start by reproducing the documented CREATE SECRET env_test configuration with an EC2 IAM Role, then observe S3 fetches before and after the temporary credentials expire. Compare the credential timestamps and 400 errors; done means the credential chain refreshes automatically after expiry without recreating the secret.

Written by the indexing model from the issue text.