Wiggins, who was entering the final year of his contract, is now set to stay in the Bay Area through 2027