Of course, it will work as it works now, no need to update to SP2 (from the avast's point of view).
The problem with SP2 is that for AMD64 CPUs, it introduces new security "improvements" (support for non-executable stack) - and the current version (396) of avast! is not compatible with this new feature.