1 2 3 4 5 6 7 8
select i.identity_public_id , s.created_at , s.expires_at , s.revoked_at from session s join identity i using (identity_id) where secret_hash = ?1;