The solenoid is toast unfortunately. The best thing to do is to leave the frunk closed for now, order the new part, and hope you can get one more open out of it to replace the part.
It's a simple job.
http://www.pelicanparts.com/cgi-bin/smart/more_info.cgi?pn=996-511-127-00-M100&catalog_description=Hood%20Lock%20Actuator%2C%20Bo xster%2FBoxster%20S%20%282001-04%29%2C%20Each%20%20%20
Good luck! Let us know if you have any questions.