This is what I mean by using Data Mapper, for example you can have psql for TGT and redis for login ticket. 

DM is very powerful ORM and there is lots of adapters for it, both sql and nosql (like redis, mongodb, cassandra etc.).
With DM you can make that each model will use different database (do not matter sql or nosql).