import re
p = re.compile(r'((?:(?!\band\b)[^\'])*(?:\'[^\'\\]*(?:\\.[^\'\\]*)*\'(?:(?!\band\b)[^\'])*)*)(?:and|$)')
s = "section_category_name = 'computer and equipment expense' and date >= 2015-01-01 and date <= 2015-03-31"
print([x for x in p.findall(s) if x])
aW1wb3J0IHJlCnAgPSByZS5jb21waWxlKHInKCg/Oig/IVxiYW5kXGIpW15cJ10pKig/OlwnW15cJ1xcXSooPzpcXC5bXlwnXFxdKikqXCcoPzooPyFcYmFuZFxiKVteXCddKSopKikoPzphbmR8JCknKQpzID0gInNlY3Rpb25fY2F0ZWdvcnlfbmFtZSA9ICdjb21wdXRlciBhbmQgZXF1aXBtZW50IGV4cGVuc2UnIGFuZCBkYXRlID49IDIwMTUtMDEtMDEgYW5kIGRhdGUgPD0gMjAxNS0wMy0zMSIKcHJpbnQoW3ggZm9yIHggaW4gcC5maW5kYWxsKHMpIGlmIHhdKQ==