UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KlM25DlrnzcE+5P0YzKp5Z8XxYeZ8OKBd+WgIxLfIXU=' 
WHERE 
  key_id = 'f53f64bec6f1fce30ee45bbb62228a4d0101ccd3ea570438cb82d411ae7184a9' 
  AND (
    token = 'KlM25DlrnzcE+5P0YzKp5Z8XxYeZ8OKBd+WgIxLfIXU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030