UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4oRg5m71uSp1G8y/yux0MHrOk1Ffud4zjfmtnwpN9DY=' 
WHERE 
  key_id = '843e3b03060f4c3140dbeda582cb68166e9ca5088197b7ee33bb0f4fe6ecfab7' 
  AND (
    token = '4oRg5m71uSp1G8y/yux0MHrOk1Ffud4zjfmtnwpN9DY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018