Hello!
It looks like there is a limitation set by Google for non-verified apps (like the one you created in Google Cloud Console), that forces the tokens to expire, if the Google Cloud Console project was not created under the same Gmail account or Google Workspace organization.
If this is a solo installation, then make sure you create the Google Sync API keys from the same Google account as the one you sync with.
If this is a company installation then you will need to create a Google Workspace and create the API keys from there, and then eventually only sync with Google Accounts of the workspace.
I'm trying to find a workaround on this as I write this.
Reference: