UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pXUvJH+A9pN5jD53v3utnRE5BrTZY7l5O4Pt6QwKzZ4=' 
WHERE 
  key_id = '58813575fe0ba3a38e0b9f6dddeb698401a7ede79fd69d5bea2170449f368735' 
  AND (
    token = 'pXUvJH+A9pN5jD53v3utnRE5BrTZY7l5O4Pt6QwKzZ4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027