Can the Refresh Tokens’ validity be increased beyond the Maximum limit in special circumstances? 

Yes, it can be increased up to a year, but this requires a formal request to Snowflake Support from your account administrator.