UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3Q2KNzoa3WOijmEIRHOCM34uahWXdA+uNYb3SzVLOIw=' 
WHERE 
  key_id = '557af01b94cea4c1f0442970c0f2a0185b81e328d096a4c6db946d5feb122461' 
  AND (
    token = '3Q2KNzoa3WOijmEIRHOCM34uahWXdA+uNYb3SzVLOIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033