UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wEob03PNe+cKrvvEu/EyILXyRnFEYRCUe9grbK0XdGU=' 
WHERE 
  key_id = 'dc475a7a82d5822ec15e31a2b189a4c0e55f36b3a93f6a3a14c1486f3d30a3ae' 
  AND (
    token = 'wEob03PNe+cKrvvEu/EyILXyRnFEYRCUe9grbK0XdGU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024