Upgrade to `aws-sdk-go-v2`

[yanyi-wego]

Overview

AWS' SDK for Go v1 will not be supported after 31 July 2025 (source). The SDK is currently only in maintenance mode since 31 July 2024.

We should upgrade our packages that use AWS SDK to v2.

$ find . -name 'go.mod' -exec grep -l 'github.com/aws/aws-sdk-go' {} +
./secretsmanager/go.mod