UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/0VVy2ASSr4HcIf0h3XCJYDzI6kjXi5UU7q2cUBRSJc=' 
WHERE 
  key_id = 'cd11e24fb80fa2065039e2d020edc117895c009bc136bb5870f69a725c3ac589' 
  AND (
    token = '/0VVy2ASSr4HcIf0h3XCJYDzI6kjXi5UU7q2cUBRSJc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00064