Super capacitor backup circuit
Yes the cap need to be rated higher than Vin or it can be destroyed.
Also I would increase R23 much more, otherwise the cap will use significant current  from the DC supply when not charged. then place a schottky which will allow easy discharge of the cap in parallel to R23. That way you don't waste all that energy as heat in R23 when powering the circuit off the cap.