UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8oFMbRl+rP4asEcausxTw96ACPOgNU0jwIBZZF0vGXQ=' 
WHERE 
  key_id = '42dd27119d0316f7d2b07be4ca0a4168c6b2b516c2cd65ef815e55ae2e983bf5' 
  AND (
    token = '8oFMbRl+rP4asEcausxTw96ACPOgNU0jwIBZZF0vGXQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045