You have supplied the context. We use "scared about" a thing or a subject area. We are scared of a thing, a person, or an action. The "scared at" use is the toughest. In that case, "at the thought" means "by the thought" or "when I have the thought of".