What is the difference between And and Or in automation conditions?

"And" means the rule only fires when every condition matches the ticket. "Or" means the rule fires as soon as any one of the conditions matches. You switch between them by clicking the And/Or toggle shown between conditions in the rule editor.