At has 2 usages:
1.) at a large area: at the mall, at home, at work
and
2.) at a specific point on the map such as an address, an intersection, a bus stop
In = inside The kitten is in the box. He is playing and he is coming in and out of the box. I am at home in my living room.