Asda has apologised after a fault with its card machines sparked long queues at checkouts and forced some stores to close completely.