There are some projects which can run pretrained deep nets in a few seconds on a smartphone, but they are definitely not "real-time" to my knowledge, though NVidia's upcoming unification of Tegra with their desktop line (and CUDA support!) may change this in a hurry.
sklearn-theano[3] doesn't support the "video stream" classification that Overfeat does, but we are planning to add it in the near future cause it is awesome :)
[1] http://on-demand-gtc.gputechconf.com/gtcnew/on-demand-gtc.ph...
That said, this deep convolutional neural net for ImageNet with 60 million parameters and 650,000 neurons took 6 days to train on two GPUs [0]