Is it possible to have two SSID's
Yes
(and separate passwords)
No
If you want the Tivo to connect to 5 GHz, you must enable the option to assign a separate name to the 5 GHz network.....then "point" the Tivo at that network. But, connecting to 5 GHz does not necessarily mean that you will have a better signal.
Have you confirmed that the Tivo has the ability to connect to a 5 GHz network?
As LaPastenague points out....unless you literally have line of sight between the Tivo and the wireless router, you will probably have a stronger (and faster) signal using 2.4 GHz.
My suggestion would be to use the same SSID for both 2.4 GHz and 5 GHz and let the Tivo connect to the best quality signal automatically. After all, isn't the best quality signal what you want?